CREATE TABLE "iws_mes_sync"
(
    "id"                 VARCHAR(50) PRIMARY KEY,
    "material_code"      VARCHAR(50) NULL DEFAULT NULL,
    "material_name"      VARCHAR(50) NULL DEFAULT NULL,
    "material_type"      VARCHAR(50) NULL DEFAULT NULL,
    "material_type_name" VARCHAR(50) NULL DEFAULT NULL,
    "dormancy_period"    INT         NULL DEFAULT NULL,
    "material_specs"     VARCHAR(50) NULL DEFAULT NULL,
    "material_unit"      VARCHAR(50) NULL DEFAULT NULL,
    "supplier_customer"  VARCHAR(50) NULL DEFAULT NULL,
    "update_time"        VARCHAR(50) NULL DEFAULT NULL,
    "overissue_limit"    INT         NULL DEFAULT NULL,
    "standard_weight"    INT         NULL DEFAULT NULL,
    "expiry_period"      INT         NULL DEFAULT NULL,
);
exec sp_addextendedproperty 'MS_Description', N'主键id', 'SCHEMA', 'dbo',
     'TABLE', 'iws_merge_task_record', 'COLUMN', 'id'
go
exec sp_addextendedproperty 'MS_Description', N'物料编码', 'SCHEMA', 'dbo',
     'TABLE', 'iws_merge_task_record', 'COLUMN', 'material_code'
go

exec sp_addextendedproperty 'MS_Description', N'物料名称', 'SCHEMA', 'dbo',
     'TABLE', 'iws_merge_task_record', 'COLUMN', 'material_name'
go
exec sp_addextendedproperty 'MS_Description', N'物料分类编码', 'SCHEMA', 'dbo',
     'TABLE', 'iws_merge_task_record', 'COLUMN', 'material_type'
go
exec sp_addextendedproperty 'MS_Description', N'物料分类名称', 'SCHEMA', 'dbo',
     'TABLE', 'iws_merge_task_record', 'COLUMN', 'material_type_name'
go
exec sp_addextendedproperty 'MS_Description', N'物料的有效期（天数）', 'SCHEMA', 'dbo',
     'TABLE', 'iws_merge_task_record', 'COLUMN', 'dormancy_period'
go
exec sp_addextendedproperty 'MS_Description', N'物料规格', 'SCHEMA', 'dbo',
     'TABLE', 'iws_merge_task_record', 'COLUMN', 'material_specs'
go
exec sp_addextendedproperty 'MS_Description', N'物料单位', 'SCHEMA', 'dbo',
     'TABLE', 'iws_merge_task_record', 'COLUMN', 'material_unit'
go
exec sp_addextendedproperty 'MS_Description', N'supplierCustomer ', 'SCHEMA', 'dbo',
     'TABLE', 'iws_merge_task_record', 'COLUMN', 'supplier_customer'
go
exec sp_addextendedproperty 'MS_Description', N'记录更新时间', 'SCHEMA', 'dbo',
     'TABLE', 'iws_merge_task_record', 'COLUMN', 'update_time'
go
exec sp_addextendedproperty 'MS_Description', N'超发限额 ', 'SCHEMA', 'dbo',
     'TABLE', 'iws_merge_task_record', 'COLUMN', 'overissue_imit'
go

exec sp_addextendedproperty 'MS_Description', N'标准重量 ', 'SCHEMA', 'dbo',
     'TABLE', 'iws_merge_task_record', 'COLUMN', 'standard_weight'
go
exec sp_addextendedproperty 'MS_Description', N'有效期 ', 'SCHEMA', 'dbo',
     'TABLE', 'iws_merge_task_record', 'COLUMN', 'expiry_period'
go
